<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title></title>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <script type="text/javascript" src="scripts/jquery-1.3.2.min.js"></script>
    <script type="text/javascript" src="scripts/jquery-ui-1.7.2.custom.min.js"></script>
    <link rel="Stylesheet" type="text/css" href="style/jqueryui/ui-lightness/jquery-ui-1.7.2.custom.css" />

    <script type="text/javascript" src="scripts/jHtmlArea-0.7.0.js"></script>
    <link rel="Stylesheet" type="text/css" href="style/jHtmlArea.css" />
</head>
<body id="dt_example" background="../images/background.png" style="background-repeat:repeat; font-size:24px;" link="#FFFFFF" alink="#FFFFFF" vlink="#FFFFFF">
	<?php require_once('database.php'); ?>
	<form action="checknewroom.php" method="post" name="form1" enctype="multipart/form-data">
    <table width="400" border="0" cellpadding="0" cellspacing="15" align="center" style="font-size:.7em;color:#FFFFFF;margin-top:50px">
    	<tr>
        	<td>
            	<label>Room name : </label>
            </td>
            <td>
            	<input type="text" name="name" id="name">
            </td>
        </tr>
        <tr>
        	<td>
            	<label>Room no : </label>
            </td>
            <td>
            	<input type="text" name="no" id="no">
            </td>
        </tr>
        <tr>
        	<td>
            	<label>Service : </label>
            </td>
            <td>
            	<select name="service">
                <?php 
					$link = connectDB();
					$tbl_name='services'; // Table name
					
					$sql="SELECT * FROM $tbl_name";
					$result=mysql_query($sql,$link);
					while ($row = mysql_fetch_assoc($result)) {
						echo "<option value=".$row['id'].">".$row["vn"]."</option>";
					}
				?>
                </select>
            </td>
        </tr>
        <tr>
        	<td>&nbsp;</td>
            <td>
            	<input type="submit" name="submit" value="Add" />
            </td>
        </tr>
    </table>
    </form>
</body>
</html>